/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package converter.core.db.entity;

import java.io.Serializable;
import java.math.BigInteger;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 *
 * @author Snark
 */
@Entity
@Table(name = "STUDENTS")
@NamedQueries({
    @NamedQuery(name = "Students.findAll", query = "SELECT s FROM Students s"),
    @NamedQuery(name = "Students.findBySysFldorder", query = "SELECT s FROM Students s WHERE s.sysFldorder = :sysFldorder"),
    @NamedQuery(name = "Students.findBySysGuid", query = "SELECT s FROM Students s WHERE s.sysGuid = :sysGuid"),
    @NamedQuery(name = "Students.findBySysState", query = "SELECT s FROM Students s WHERE s.sysState = :sysState"),
    @NamedQuery(name = "Students.findBySysRev", query = "SELECT s FROM Students s WHERE s.sysRev = :sysRev"),
    @NamedQuery(name = "Students.findBySysCreated", query = "SELECT s FROM Students s WHERE s.sysCreated = :sysCreated"),
    @NamedQuery(name = "Students.findBySysUpdated", query = "SELECT s FROM Students s WHERE s.sysUpdated = :sysUpdated"),
    @NamedQuery(name = "Students.findBySysCreator", query = "SELECT s FROM Students s WHERE s.sysCreator = :sysCreator"),
    @NamedQuery(name = "Students.findBySysUser", query = "SELECT s FROM Students s WHERE s.sysUser = :sysUser"),
    @NamedQuery(name = "Students.findBySysGuidfk", query = "SELECT s FROM Students s WHERE s.sysGuidfk = :sysGuidfk"),
    @NamedQuery(name = "Students.findBySysParentguid", query = "SELECT s FROM Students s WHERE s.sysParentguid = :sysParentguid"),
    @NamedQuery(name = "Students.findByCode", query = "SELECT s FROM Students s WHERE s.code = :code"),
    @NamedQuery(name = "Students.findBySecondname", query = "SELECT s FROM Students s WHERE s.secondname = :secondname"),
    @NamedQuery(name = "Students.findByFirstname", query = "SELECT s FROM Students s WHERE s.firstname = :firstname"),
    @NamedQuery(name = "Students.findByPatronymic", query = "SELECT s FROM Students s WHERE s.patronymic = :patronymic"),
    @NamedQuery(name = "Students.findBySex", query = "SELECT s FROM Students s WHERE s.sex = :sex"),
    @NamedQuery(name = "Students.findByBirthday", query = "SELECT s FROM Students s WHERE s.birthday = :birthday"),
    @NamedQuery(name = "Students.findByCountryfk", query = "SELECT s FROM Students s WHERE s.countryfk = :countryfk"),
    @NamedQuery(name = "Students.findByBirthplace", query = "SELECT s FROM Students s WHERE s.birthplace = :birthplace"),
    @NamedQuery(name = "Students.findByFacultiefk", query = "SELECT s FROM Students s WHERE s.facultiefk = :facultiefk"),
    @NamedQuery(name = "Students.findBySpeciality", query = "SELECT s FROM Students s WHERE s.speciality = :speciality"),
    @NamedQuery(name = "Students.findByTrainingDirectionfk", query = "SELECT s FROM Students s WHERE s.trainingDirectionfk = :trainingDirectionfk"),
    @NamedQuery(name = "Students.findByTuitionfk", query = "SELECT s FROM Students s WHERE s.tuitionfk = :tuitionfk"),
    @NamedQuery(name = "Students.findByCoursefk", query = "SELECT s FROM Students s WHERE s.coursefk = :coursefk"),
    @NamedQuery(name = "Students.findByGroupfk", query = "SELECT s FROM Students s WHERE s.groupfk = :groupfk"),
    @NamedQuery(name = "Students.findByEdulevelfk", query = "SELECT s FROM Students s WHERE s.edulevelfk = :edulevelfk"),
    @NamedQuery(name = "Students.findByPaid", query = "SELECT s FROM Students s WHERE s.paid = :paid"),
    @NamedQuery(name = "Students.findByJoinlinefk", query = "SELECT s FROM Students s WHERE s.joinlinefk = :joinlinefk"),
    @NamedQuery(name = "Students.findByJoinn", query = "SELECT s FROM Students s WHERE s.joinn = :joinn"),
    @NamedQuery(name = "Students.findByLeave", query = "SELECT s FROM Students s WHERE s.leave = :leave"),
    @NamedQuery(name = "Students.findByTransfer", query = "SELECT s FROM Students s WHERE s.transfer = :transfer"),
    @NamedQuery(name = "Students.findByChangefio", query = "SELECT s FROM Students s WHERE s.changefio = :changefio"),
    @NamedQuery(name = "Students.findByAdress", query = "SELECT s FROM Students s WHERE s.adress = :adress"),
    @NamedQuery(name = "Students.findByPhone", query = "SELECT s FROM Students s WHERE s.phone = :phone"),
    @NamedQuery(name = "Students.findByHostelfk", query = "SELECT s FROM Students s WHERE s.hostelfk = :hostelfk"),
    @NamedQuery(name = "Students.findByDocType", query = "SELECT s FROM Students s WHERE s.docType = :docType"),
    @NamedQuery(name = "Students.findByPassport", query = "SELECT s FROM Students s WHERE s.passport = :passport"),
    @NamedQuery(name = "Students.findByPassportNum", query = "SELECT s FROM Students s WHERE s.passportNum = :passportNum"),
    @NamedQuery(name = "Students.findByPassportdate", query = "SELECT s FROM Students s WHERE s.passportdate = :passportdate"),
    @NamedQuery(name = "Students.findByPassportGet", query = "SELECT s FROM Students s WHERE s.passportGet = :passportGet"),
    @NamedQuery(name = "Students.findByPassportdateend", query = "SELECT s FROM Students s WHERE s.passportdateend = :passportdateend"),
    @NamedQuery(name = "Students.findByArrivaldate", query = "SELECT s FROM Students s WHERE s.arrivaldate = :arrivaldate"),
    @NamedQuery(name = "Students.findByMigrationcard", query = "SELECT s FROM Students s WHERE s.migrationcard = :migrationcard"),
    @NamedQuery(name = "Students.findByRegdateend", query = "SELECT s FROM Students s WHERE s.regdateend = :regdateend"),
    @NamedQuery(name = "Students.findByVisanumber", query = "SELECT s FROM Students s WHERE s.visanumber = :visanumber"),
    @NamedQuery(name = "Students.findByVisadatestart", query = "SELECT s FROM Students s WHERE s.visadatestart = :visadatestart"),
    @NamedQuery(name = "Students.findByVisadateend", query = "SELECT s FROM Students s WHERE s.visadateend = :visadateend"),
    @NamedQuery(name = "Students.findByResolnum", query = "SELECT s FROM Students s WHERE s.resolnum = :resolnum"),
    @NamedQuery(name = "Students.findByResolissuedate", query = "SELECT s FROM Students s WHERE s.resolissuedate = :resolissuedate"),
    @NamedQuery(name = "Students.findByResulend", query = "SELECT s FROM Students s WHERE s.resulend = :resulend"),
    @NamedQuery(name = "Students.findByResidnum", query = "SELECT s FROM Students s WHERE s.residnum = :residnum"),
    @NamedQuery(name = "Students.findByResidissuedate", query = "SELECT s FROM Students s WHERE s.residissuedate = :residissuedate"),
    @NamedQuery(name = "Students.findByNostrification", query = "SELECT s FROM Students s WHERE s.nostrification = :nostrification"),
    @NamedQuery(name = "Students.findByResidend", query = "SELECT s FROM Students s WHERE s.residend = :residend"),
    @NamedQuery(name = "Students.findBySnils", query = "SELECT s FROM Students s WHERE s.snils = :snils"),
    @NamedQuery(name = "Students.findByEdudoc", query = "SELECT s FROM Students s WHERE s.edudoc = :edudoc")})
public class Students implements Serializable {
    private static final long serialVersionUID = 1L;
    @Column(name = "SYS_FLDORDER")
    private Integer sysFldorder;
    @Id
    @Basic(optional = false)
    @Column(name = "SYS_GUID")
    private String sysGuid;
    @Column(name = "SYS_STATE")
    private Integer sysState;
    @Column(name = "SYS_REV")
    private BigInteger sysRev;
    @Column(name = "SYS_CREATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysCreated;
    @Column(name = "SYS_UPDATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysUpdated;
    @Column(name = "SYS_CREATOR")
    private String sysCreator;
    @Column(name = "SYS_USER")
    private String sysUser;
    @Column(name = "SYS_GUIDFK")
    private String sysGuidfk;
    @Column(name = "SYS_PARENTGUID")
    private String sysParentguid;
    @Column(name = "CODE")
    private Integer code;
    @Column(name = "SECONDNAME")
    private String secondname;
    @Column(name = "FIRSTNAME")
    private String firstname;
    @Column(name = "PATRONYMIC")
    private String patronymic;
    @Column(name = "SEX")
    private String sex;
    @Column(name = "BIRTHDAY")
    @Temporal(TemporalType.DATE)
    private Date birthday;
    @Column(name = "COUNTRYFK")
    private String countryfk;
    @Column(name = "BIRTHPLACE")
    private String birthplace;
    @Column(name = "FACULTIEFK")
    private String facultiefk;
    @Column(name = "SPECIALITY")
    private String speciality;
    @Column(name = "TRAINING_DIRECTIONFK")
    private String trainingDirectionfk;
    @Column(name = "TUITIONFK")
    private String tuitionfk;
    @Column(name = "COURSEFK")
    private String coursefk;
    @Column(name = "GROUPFK")
    private String groupfk;
    @Column(name = "EDULEVELFK")
    private String edulevelfk;
    @Column(name = "PAID")
    private String paid;
    @Column(name = "JOINLINEFK")
    private String joinlinefk;
    @Column(name = "JOINN")
    private String joinn;
    @Column(name = "LEAVE")
    private String leave;
    @Column(name = "TRANSFER")
    private String transfer;
    @Column(name = "CHANGEFIO")
    private String changefio;
    @Column(name = "ADRESS")
    private String adress;
    @Column(name = "PHONE")
    private String phone;
    @Column(name = "HOSTELFK")
    private String hostelfk;
    @Column(name = "DOC_TYPE")
    private String docType;
    @Column(name = "PASSPORT")
    private String passport;
    @Column(name = "PASSPORT_NUM")
    private String passportNum;
    @Column(name = "PASSPORTDATE")
    @Temporal(TemporalType.DATE)
    private Date passportdate;
    @Column(name = "PASSPORT_GET")
    private String passportGet;
    @Column(name = "PASSPORTDATEEND")
    @Temporal(TemporalType.DATE)
    private Date passportdateend;
    @Column(name = "ARRIVALDATE")
    @Temporal(TemporalType.DATE)
    private Date arrivaldate;
    @Column(name = "MIGRATIONCARD")
    private Integer migrationcard;
    @Column(name = "REGDATEEND")
    @Temporal(TemporalType.DATE)
    private Date regdateend;
    @Column(name = "VISANUMBER")
    private Integer visanumber;
    @Column(name = "VISADATESTART")
    @Temporal(TemporalType.DATE)
    private Date visadatestart;
    @Column(name = "VISADATEEND")
    @Temporal(TemporalType.DATE)
    private Date visadateend;
    @Column(name = "RESOLNUM")
    private Integer resolnum;
    @Column(name = "RESOLISSUEDATE")
    @Temporal(TemporalType.DATE)
    private Date resolissuedate;
    @Column(name = "RESULEND")
    @Temporal(TemporalType.DATE)
    private Date resulend;
    @Column(name = "RESIDNUM")
    private Integer residnum;
    @Column(name = "RESIDISSUEDATE")
    @Temporal(TemporalType.DATE)
    private Date residissuedate;
    @Column(name = "NOSTRIFICATION")
    private Integer nostrification;
    @Column(name = "RESIDEND")
    @Temporal(TemporalType.DATE)
    private Date residend;
    @Column(name = "SNILS")
    private String snils;
    @Column(name = "EDUDOC")
    private String edudoc;

    public Students() {
    }

    public Students(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysFldorder() {
        return sysFldorder;
    }

    public void setSysFldorder(Integer sysFldorder) {
        this.sysFldorder = sysFldorder;
    }

    public String getSysGuid() {
        return sysGuid;
    }

    public void setSysGuid(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysState() {
        return sysState;
    }

    public void setSysState(Integer sysState) {
        this.sysState = sysState;
    }

    public BigInteger getSysRev() {
        return sysRev;
    }

    public void setSysRev(BigInteger sysRev) {
        this.sysRev = sysRev;
    }

    public Date getSysCreated() {
        return sysCreated;
    }

    public void setSysCreated(Date sysCreated) {
        this.sysCreated = sysCreated;
    }

    public Date getSysUpdated() {
        return sysUpdated;
    }

    public void setSysUpdated(Date sysUpdated) {
        this.sysUpdated = sysUpdated;
    }

    public String getSysCreator() {
        return sysCreator;
    }

    public void setSysCreator(String sysCreator) {
        this.sysCreator = sysCreator;
    }

    public String getSysUser() {
        return sysUser;
    }

    public void setSysUser(String sysUser) {
        this.sysUser = sysUser;
    }

    public String getSysGuidfk() {
        return sysGuidfk;
    }

    public void setSysGuidfk(String sysGuidfk) {
        this.sysGuidfk = sysGuidfk;
    }

    public String getSysParentguid() {
        return sysParentguid;
    }

    public void setSysParentguid(String sysParentguid) {
        this.sysParentguid = sysParentguid;
    }

    public Integer getCode() {
        return code;
    }

    public void setCode(Integer code) {
        this.code = code;
    }

    public String getSecondname() {
        return secondname;
    }

    public void setSecondname(String secondname) {
        this.secondname = secondname;
    }

    public String getFirstname() {
        return firstname;
    }

    public void setFirstname(String firstname) {
        this.firstname = firstname;
    }

    public String getPatronymic() {
        return patronymic;
    }

    public void setPatronymic(String patronymic) {
        this.patronymic = patronymic;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getCountryfk() {
        return countryfk;
    }

    public void setCountryfk(String countryfk) {
        this.countryfk = countryfk;
    }

    public String getBirthplace() {
        return birthplace;
    }

    public void setBirthplace(String birthplace) {
        this.birthplace = birthplace;
    }

    public String getFacultiefk() {
        return facultiefk;
    }

    public void setFacultiefk(String facultiefk) {
        this.facultiefk = facultiefk;
    }

    public String getSpeciality() {
        return speciality;
    }

    public void setSpeciality(String speciality) {
        this.speciality = speciality;
    }

    public String getTrainingDirectionfk() {
        return trainingDirectionfk;
    }

    public void setTrainingDirectionfk(String trainingDirectionfk) {
        this.trainingDirectionfk = trainingDirectionfk;
    }

    public String getTuitionfk() {
        return tuitionfk;
    }

    public void setTuitionfk(String tuitionfk) {
        this.tuitionfk = tuitionfk;
    }

    public String getCoursefk() {
        return coursefk;
    }

    public void setCoursefk(String coursefk) {
        this.coursefk = coursefk;
    }

    public String getGroupfk() {
        return groupfk;
    }

    public void setGroupfk(String groupfk) {
        this.groupfk = groupfk;
    }

    public String getEdulevelfk() {
        return edulevelfk;
    }

    public void setEdulevelfk(String edulevelfk) {
        this.edulevelfk = edulevelfk;
    }

    public String getPaid() {
        return paid;
    }

    public void setPaid(String paid) {
        this.paid = paid;
    }

    public String getJoinlinefk() {
        return joinlinefk;
    }

    public void setJoinlinefk(String joinlinefk) {
        this.joinlinefk = joinlinefk;
    }

    public String getJoinn() {
        return joinn;
    }

    public void setJoinn(String joinn) {
        this.joinn = joinn;
    }

    public String getLeave() {
        return leave;
    }

    public void setLeave(String leave) {
        this.leave = leave;
    }

    public String getTransfer() {
        return transfer;
    }

    public void setTransfer(String transfer) {
        this.transfer = transfer;
    }

    public String getChangefio() {
        return changefio;
    }

    public void setChangefio(String changefio) {
        this.changefio = changefio;
    }

    public String getAdress() {
        return adress;
    }

    public void setAdress(String adress) {
        this.adress = adress;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getHostelfk() {
        return hostelfk;
    }

    public void setHostelfk(String hostelfk) {
        this.hostelfk = hostelfk;
    }

    public String getDocType() {
        return docType;
    }

    public void setDocType(String docType) {
        this.docType = docType;
    }

    public String getPassport() {
        return passport;
    }

    public void setPassport(String passport) {
        this.passport = passport;
    }

    public String getPassportNum() {
        return passportNum;
    }

    public void setPassportNum(String passportNum) {
        this.passportNum = passportNum;
    }

    public Date getPassportdate() {
        return passportdate;
    }

    public void setPassportdate(Date passportdate) {
        this.passportdate = passportdate;
    }

    public String getPassportGet() {
        return passportGet;
    }

    public void setPassportGet(String passportGet) {
        this.passportGet = passportGet;
    }

    public Date getPassportdateend() {
        return passportdateend;
    }

    public void setPassportdateend(Date passportdateend) {
        this.passportdateend = passportdateend;
    }

    public Date getArrivaldate() {
        return arrivaldate;
    }

    public void setArrivaldate(Date arrivaldate) {
        this.arrivaldate = arrivaldate;
    }

    public Integer getMigrationcard() {
        return migrationcard;
    }

    public void setMigrationcard(Integer migrationcard) {
        this.migrationcard = migrationcard;
    }

    public Date getRegdateend() {
        return regdateend;
    }

    public void setRegdateend(Date regdateend) {
        this.regdateend = regdateend;
    }

    public Integer getVisanumber() {
        return visanumber;
    }

    public void setVisanumber(Integer visanumber) {
        this.visanumber = visanumber;
    }

    public Date getVisadatestart() {
        return visadatestart;
    }

    public void setVisadatestart(Date visadatestart) {
        this.visadatestart = visadatestart;
    }

    public Date getVisadateend() {
        return visadateend;
    }

    public void setVisadateend(Date visadateend) {
        this.visadateend = visadateend;
    }

    public Integer getResolnum() {
        return resolnum;
    }

    public void setResolnum(Integer resolnum) {
        this.resolnum = resolnum;
    }

    public Date getResolissuedate() {
        return resolissuedate;
    }

    public void setResolissuedate(Date resolissuedate) {
        this.resolissuedate = resolissuedate;
    }

    public Date getResulend() {
        return resulend;
    }

    public void setResulend(Date resulend) {
        this.resulend = resulend;
    }

    public Integer getResidnum() {
        return residnum;
    }

    public void setResidnum(Integer residnum) {
        this.residnum = residnum;
    }

    public Date getResidissuedate() {
        return residissuedate;
    }

    public void setResidissuedate(Date residissuedate) {
        this.residissuedate = residissuedate;
    }

    public Integer getNostrification() {
        return nostrification;
    }

    public void setNostrification(Integer nostrification) {
        this.nostrification = nostrification;
    }

    public Date getResidend() {
        return residend;
    }

    public void setResidend(Date residend) {
        this.residend = residend;
    }

    public String getSnils() {
        return snils;
    }

    public void setSnils(String snils) {
        this.snils = snils;
    }

    public String getEdudoc() {
        return edudoc;
    }

    public void setEdudoc(String edudoc) {
        this.edudoc = edudoc;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (sysGuid != null ? sysGuid.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Students)) {
            return false;
        }
        Students other = (Students) object;
        if ((this.sysGuid == null && other.sysGuid != null) || (this.sysGuid != null && !this.sysGuid.equals(other.sysGuid))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "javaapplication1.entity.Students[ sysGuid=" + sysGuid + " ]";
    }
    
}
